Opened 10 years ago
Closed 10 years ago
#3070 closed enhancement (fixed)
Simplify geometry type constraint
| Reported by: | strk | Owned by: | strk |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.2.0 |
| Component: | postgis | Version: | master |
| Keywords: | Cc: |
Description
According to Andrew Gierth we're putting a superfluous condition in our geometry type constraint:
http://www.postgresql.org/message-id/87bnk7z9h6.fsf@news-spur.riddles.org.uk
To be removed (doesn't really need to be backported)
BTW, we do not add the superfluous condition in the dimension or srid constraints…
Change History (3)
comment:1 by , 10 years ago
comment:2 by , 10 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
Note:
See TracTickets
for help on using tickets.
NOTE: removing the "or IS NULL" condition works around a limitation of PostgreSQL that makes it unable to use table constraint to skip scan of tables with an upfront check (subject of the linked thread)